<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  
  <title>oracle spatial | Hexo</title>
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
  <meta name="description" content="12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210">
<meta property="og:type" content="article">
<meta property="og:title" content="oracle spatial">
<meta property="og:url" content="http://yoursite.com/2016/01/27/database/10.oracle spatial/index.html">
<meta property="og:site_name" content="Hexo">
<meta property="og:description" content="12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210">
<meta property="og:updated_time" content="2016-01-29T17:47:36.000Z">
<meta name="twitter:card" content="summary">
<meta name="twitter:title" content="oracle spatial">
<meta name="twitter:description" content="12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210">
  
    <link rel="alternative" href="/atom.xml" title="Hexo" type="application/atom+xml">
  
  
    <link rel="icon" href="/favicon.png">
  
  <link href="//fonts.googleapis.com/css?family=Source+Code+Pro" rel="stylesheet" type="text/css">
  <link rel="stylesheet" href="/css/style.css" type="text/css">
  

</head>
<body>
  <div id="container">
    <div id="wrap">
      <header id="header">
  <div id="banner"></div>
  <div id="header-outer" class="outer">
    <div id="header-title" class="inner">
      <h1 id="logo-wrap">
        <a href="/" id="logo">Hexo</a>
      </h1>
      
    </div>
    <div id="header-inner" class="inner">
      <nav id="main-nav">
        <a id="main-nav-toggle" class="nav-icon"></a>
        
          <a class="main-nav-link" href="/">Home</a>
        
          <a class="main-nav-link" href="/archives">Archives</a>
        
      </nav>
      <nav id="sub-nav">
        
          <a id="nav-rss-link" class="nav-icon" href="/atom.xml" title="RSS Feed"></a>
        
        <a id="nav-search-btn" class="nav-icon" title="Search"></a>
      </nav>
      <div id="search-form-wrap">
        <form action="//google.com/search" method="get" accept-charset="UTF-8" class="search-form"><input type="search" name="q" results="0" class="search-form-input" placeholder="Search"><button type="submit" class="search-form-submit">&#xF002;</button><input type="hidden" name="sitesearch" value="http://yoursite.com"></form>
      </div>
    </div>
  </div>
</header>
      <div class="outer">
        <section id="main"><article id="post-database/10.oracle spatial" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/2016/01/27/database/10.oracle spatial/" class="article-date">
  <time datetime="2016-01-27T08:07:00.000Z" itemprop="datePublished">2016-01-27</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/categories/database/">database</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 class="article-title" itemprop="name">
      oracle spatial
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br><span class="line">12</span><br><span class="line">13</span><br><span class="line">14</span><br><span class="line">15</span><br><span class="line">16</span><br><span class="line">17</span><br><span class="line">18</span><br><span class="line">19</span><br><span class="line">20</span><br><span class="line">21</span><br><span class="line">22</span><br><span class="line">23</span><br><span class="line">24</span><br><span class="line">25</span><br><span class="line">26</span><br><span class="line">27</span><br><span class="line">28</span><br><span class="line">29</span><br><span class="line">30</span><br><span class="line">31</span><br><span class="line">32</span><br><span class="line">33</span><br><span class="line">34</span><br><span class="line">35</span><br><span class="line">36</span><br><span class="line">37</span><br><span class="line">38</span><br><span class="line">39</span><br><span class="line">40</span><br><span class="line">41</span><br><span class="line">42</span><br><span class="line">43</span><br><span class="line">44</span><br><span class="line">45</span><br><span class="line">46</span><br><span class="line">47</span><br><span class="line">48</span><br><span class="line">49</span><br><span class="line">50</span><br><span class="line">51</span><br><span class="line">52</span><br><span class="line">53</span><br><span class="line">54</span><br><span class="line">55</span><br><span class="line">56</span><br><span class="line">57</span><br><span class="line">58</span><br><span class="line">59</span><br><span class="line">60</span><br><span class="line">61</span><br><span class="line">62</span><br><span class="line">63</span><br><span class="line">64</span><br><span class="line">65</span><br><span class="line">66</span><br><span class="line">67</span><br><span class="line">68</span><br><span class="line">69</span><br><span class="line">70</span><br><span class="line">71</span><br><span class="line">72</span><br><span class="line">73</span><br><span class="line">74</span><br><span class="line">75</span><br><span class="line">76</span><br><span class="line">77</span><br><span class="line">78</span><br><span class="line">79</span><br><span class="line">80</span><br><span class="line">81</span><br><span class="line">82</span><br><span class="line">83</span><br><span class="line">84</span><br><span class="line">85</span><br><span class="line">86</span><br><span class="line">87</span><br><span class="line">88</span><br><span class="line">89</span><br><span class="line">90</span><br><span class="line">91</span><br><span class="line">92</span><br><span class="line">93</span><br><span class="line">94</span><br><span class="line">95</span><br><span class="line">96</span><br><span class="line">97</span><br><span class="line">98</span><br><span class="line">99</span><br><span class="line">100</span><br><span class="line">101</span><br><span class="line">102</span><br><span class="line">103</span><br><span class="line">104</span><br><span class="line">105</span><br><span class="line">106</span><br><span class="line">107</span><br><span class="line">108</span><br><span class="line">109</span><br><span class="line">110</span><br><span class="line">111</span><br><span class="line">112</span><br><span class="line">113</span><br><span class="line">114</span><br><span class="line">115</span><br><span class="line">116</span><br><span class="line">117</span><br><span class="line">118</span><br><span class="line">119</span><br><span class="line">120</span><br><span class="line">121</span><br><span class="line">122</span><br><span class="line">123</span><br><span class="line">124</span><br><span class="line">125</span><br><span class="line">126</span><br><span class="line">127</span><br><span class="line">128</span><br><span class="line">129</span><br><span class="line">130</span><br><span class="line">131</span><br><span class="line">132</span><br><span class="line">133</span><br><span class="line">134</span><br><span class="line">135</span><br><span class="line">136</span><br><span class="line">137</span><br><span class="line">138</span><br><span class="line">139</span><br><span class="line">140</span><br><span class="line">141</span><br><span class="line">142</span><br><span class="line">143</span><br><span class="line">144</span><br><span class="line">145</span><br><span class="line">146</span><br><span class="line">147</span><br><span class="line">148</span><br><span class="line">149</span><br><span class="line">150</span><br><span class="line">151</span><br><span class="line">152</span><br><span class="line">153</span><br><span class="line">154</span><br><span class="line">155</span><br><span class="line">156</span><br><span class="line">157</span><br><span class="line">158</span><br><span class="line">159</span><br><span class="line">160</span><br><span class="line">161</span><br><span class="line">162</span><br><span class="line">163</span><br><span class="line">164</span><br><span class="line">165</span><br><span class="line">166</span><br><span class="line">167</span><br><span class="line">168</span><br><span class="line">169</span><br><span class="line">170</span><br><span class="line">171</span><br><span class="line">172</span><br><span class="line">173</span><br><span class="line">174</span><br><span class="line">175</span><br><span class="line">176</span><br><span class="line">177</span><br><span class="line">178</span><br><span class="line">179</span><br><span class="line">180</span><br><span class="line">181</span><br><span class="line">182</span><br><span class="line">183</span><br><span class="line">184</span><br><span class="line">185</span><br><span class="line">186</span><br><span class="line">187</span><br><span class="line">188</span><br><span class="line">189</span><br><span class="line">190</span><br><span class="line">191</span><br><span class="line">192</span><br><span class="line">193</span><br><span class="line">194</span><br><span class="line">195</span><br><span class="line">196</span><br><span class="line">197</span><br><span class="line">198</span><br><span class="line">199</span><br><span class="line">200</span><br><span class="line">201</span><br><span class="line">202</span><br><span class="line">203</span><br><span class="line">204</span><br><span class="line">205</span><br><span class="line">206</span><br><span class="line">207</span><br><span class="line">208</span><br><span class="line">209</span><br><span class="line">210</span><br></pre></td><td class="code"><pre><span class="line"><span class="operator"><span class="keyword">select</span> * <span class="keyword">from</span> user_sdo_geom_metadata;</span></span><br><span class="line"><span class="operator"><span class="keyword">delete</span> <span class="keyword">from</span> user_sdo_geom_metadata <span class="keyword">where</span> table_name <span class="keyword">in</span> (<span class="string">'VGNSS'</span>, <span class="string">'VGEOCONPOINT'</span>, <span class="string">'VLEVELLINE'</span>);</span></span><br><span class="line"><span class="operator"><span class="keyword">delete</span> <span class="keyword">from</span> user_sdo_geom_metadata <span class="keyword">where</span> table_name <span class="keyword">in</span> (<span class="string">'TGNSS'</span>, <span class="string">'TGEOCONPOINT'</span>, <span class="string">'TLEVELLINE'</span>);</span></span><br><span class="line"></span><br><span class="line"><span class="operator"><span class="keyword">INSERT</span> <span class="keyword">INTO</span> user_sdo_geom_metadata</span><br><span class="line">  (table_name, column_name, diminfo, srid)</span><br><span class="line"><span class="keyword">VALUES</span></span><br><span class="line">  (<span class="string">'TGNSS'</span>, <span class="comment">-- 表名</span></span><br><span class="line">   <span class="string">'GEOM'</span>, <span class="comment">-- geometry字段</span></span><br><span class="line">   SDO_DIM_ARRAY <span class="comment">-- DIMINFO 属性存储空间表中空间数据的范围和容差</span></span><br><span class="line">   (SDO_DIM_ELEMENT(<span class="string">'X'</span>, <span class="comment">-- 第一个元键名称</span></span><br><span class="line">                    -<span class="number">180</span>, <span class="comment">-- 最小X</span></span><br><span class="line">                    <span class="number">180</span>, <span class="comment">-- 最大X</span></span><br><span class="line">                    <span class="number">0.005</span>), <span class="comment">-- 容差0.005度</span></span><br><span class="line">    SDO_DIM_ELEMENT(<span class="string">'Y'</span>, <span class="comment">-- 第二个元键名称</span></span><br><span class="line">                    -<span class="number">90</span>, <span class="comment">-- 最小Y</span></span><br><span class="line">                    <span class="number">90</span>, <span class="comment">-- 最大Y</span></span><br><span class="line">                    <span class="number">0.005</span>) <span class="comment">-- 容差0.005度</span></span><br><span class="line">    ),</span><br><span class="line">   <span class="number">4326</span></span><br><span class="line">   <span class="comment">--8307 -- SRID</span></span><br><span class="line">   );</span></span><br><span class="line"></span><br><span class="line"><span class="operator"><span class="keyword">INSERT</span> <span class="keyword">INTO</span> user_sdo_geom_metadata</span><br><span class="line">  (table_name, column_name, diminfo, srid)</span><br><span class="line"><span class="keyword">VALUES</span></span><br><span class="line">  (<span class="string">'TGEOCONPOINT'</span>, <span class="comment">-- 表名</span></span><br><span class="line">   <span class="string">'GEOM'</span>, <span class="comment">-- geometry字段</span></span><br><span class="line">   SDO_DIM_ARRAY <span class="comment">-- DIMINFO 属性存储空间表中空间数据的范围和容差</span></span><br><span class="line">   (SDO_DIM_ELEMENT(<span class="string">'X'</span>, <span class="comment">-- 第一个元键名称</span></span><br><span class="line">                    -<span class="number">180</span>, <span class="comment">-- 最小X</span></span><br><span class="line">                    <span class="number">180</span>, <span class="comment">-- 最大X</span></span><br><span class="line">                    <span class="number">0.005</span>), <span class="comment">-- 容差0.005度</span></span><br><span class="line">    SDO_DIM_ELEMENT(<span class="string">'Y'</span>, <span class="comment">-- 第二个元键名称</span></span><br><span class="line">                    -<span class="number">90</span>, <span class="comment">-- 最小Y</span></span><br><span class="line">                    <span class="number">90</span>, <span class="comment">-- 最大Y</span></span><br><span class="line">                    <span class="number">0.005</span>) <span class="comment">-- 容差0.005度</span></span><br><span class="line">    ),</span><br><span class="line">   <span class="number">4326</span></span><br><span class="line">   <span class="comment">--8307 -- SRID</span></span><br><span class="line">   );</span></span><br><span class="line"></span><br><span class="line"><span class="operator"><span class="keyword">INSERT</span> <span class="keyword">INTO</span> user_sdo_geom_metadata</span><br><span class="line">  (table_name, column_name, diminfo, srid)</span><br><span class="line"><span class="keyword">VALUES</span></span><br><span class="line">  (<span class="string">'TLEVELLINE'</span>, <span class="comment">-- 表名</span></span><br><span class="line">   <span class="string">'GEOM'</span>, <span class="comment">-- geometry字段</span></span><br><span class="line">   SDO_DIM_ARRAY <span class="comment">-- DIMINFO 属性存储空间表中空间数据的范围和容差</span></span><br><span class="line">   (SDO_DIM_ELEMENT(<span class="string">'X'</span>, <span class="comment">-- 第一个元键名称</span></span><br><span class="line">                    -<span class="number">180</span>, <span class="comment">-- 最小X</span></span><br><span class="line">                    <span class="number">180</span>, <span class="comment">-- 最大X</span></span><br><span class="line">                    <span class="number">0.005</span>), <span class="comment">-- 容差0.005度</span></span><br><span class="line">    SDO_DIM_ELEMENT(<span class="string">'Y'</span>, <span class="comment">-- 第二个元键名称</span></span><br><span class="line">                    -<span class="number">90</span>, <span class="comment">-- 最小Y</span></span><br><span class="line">                    <span class="number">90</span>, <span class="comment">-- 最大Y</span></span><br><span class="line">                    <span class="number">0.005</span>) <span class="comment">-- 容差0.005度</span></span><br><span class="line">    ),</span><br><span class="line">   <span class="number">4326</span></span><br><span class="line">   <span class="comment">--8307 -- SRID</span></span><br><span class="line">   );</span></span><br><span class="line">   </span><br><span class="line"><span class="operator"><span class="keyword">INSERT</span> <span class="keyword">INTO</span> user_sdo_geom_metadata</span><br><span class="line">  (table_name, column_name, diminfo, srid)</span><br><span class="line"><span class="keyword">VALUES</span></span><br><span class="line">  (<span class="string">'VGNSS'</span>, <span class="comment">-- 表名</span></span><br><span class="line">   <span class="string">'GEOM'</span>, <span class="comment">-- geometry字段</span></span><br><span class="line">   SDO_DIM_ARRAY <span class="comment">-- DIMINFO 属性存储空间表中空间数据的范围和容差</span></span><br><span class="line">   (SDO_DIM_ELEMENT(<span class="string">'X'</span>, <span class="comment">-- 第一个元键名称</span></span><br><span class="line">                    -<span class="number">180</span>, <span class="comment">-- 最小X</span></span><br><span class="line">                    <span class="number">180</span>, <span class="comment">-- 最大X</span></span><br><span class="line">                    <span class="number">0.005</span>), <span class="comment">-- 容差0.005度</span></span><br><span class="line">    SDO_DIM_ELEMENT(<span class="string">'Y'</span>, <span class="comment">-- 第二个元键名称</span></span><br><span class="line">                    -<span class="number">90</span>, <span class="comment">-- 最小Y</span></span><br><span class="line">                    <span class="number">90</span>, <span class="comment">-- 最大Y</span></span><br><span class="line">                    <span class="number">0.005</span>) <span class="comment">-- 容差0.005度</span></span><br><span class="line">    ),</span><br><span class="line">   <span class="number">4326</span></span><br><span class="line">   <span class="comment">-- 8307 -- SRID</span></span><br><span class="line">   );</span></span><br><span class="line"></span><br><span class="line"><span class="operator"><span class="keyword">INSERT</span> <span class="keyword">INTO</span> user_sdo_geom_metadata</span><br><span class="line">  (table_name, column_name, diminfo, srid)</span><br><span class="line"><span class="keyword">VALUES</span></span><br><span class="line">  (<span class="string">'VGEOCONPOINT'</span>, <span class="comment">-- 表名</span></span><br><span class="line">   <span class="string">'GEOM'</span>, <span class="comment">-- geometry字段</span></span><br><span class="line">   SDO_DIM_ARRAY <span class="comment">-- DIMINFO 属性存储空间表中空间数据的范围和容差</span></span><br><span class="line">   (SDO_DIM_ELEMENT(<span class="string">'X'</span>, <span class="comment">-- 第一个元键名称</span></span><br><span class="line">                    -<span class="number">180</span>, <span class="comment">-- 最小X</span></span><br><span class="line">                    <span class="number">180</span>, <span class="comment">-- 最大X</span></span><br><span class="line">                    <span class="number">0.005</span>), <span class="comment">-- 容差0.005度</span></span><br><span class="line">    SDO_DIM_ELEMENT(<span class="string">'Y'</span>, <span class="comment">-- 第二个元键名称</span></span><br><span class="line">                    -<span class="number">90</span>, <span class="comment">-- 最小Y</span></span><br><span class="line">                    <span class="number">90</span>, <span class="comment">-- 最大Y</span></span><br><span class="line">                    <span class="number">0.005</span>) <span class="comment">-- 容差0.005度</span></span><br><span class="line">    ),</span><br><span class="line">   <span class="number">4326</span></span><br><span class="line">   <span class="comment">--8307 -- SRID</span></span><br><span class="line">   );</span></span><br><span class="line">   </span><br><span class="line"><span class="operator"><span class="keyword">INSERT</span> <span class="keyword">INTO</span> user_sdo_geom_metadata</span><br><span class="line">  (table_name, column_name, diminfo, srid)</span><br><span class="line"><span class="keyword">VALUES</span></span><br><span class="line">  (<span class="string">'VLEVELLINE'</span>, <span class="comment">-- 表名</span></span><br><span class="line">   <span class="string">'GEOM'</span>, <span class="comment">-- geometry字段</span></span><br><span class="line">   SDO_DIM_ARRAY <span class="comment">-- DIMINFO 属性存储空间表中空间数据的范围和容差</span></span><br><span class="line">   (SDO_DIM_ELEMENT(<span class="string">'X'</span>, <span class="comment">-- 第一个元键名称</span></span><br><span class="line">                    -<span class="number">180</span>, <span class="comment">-- 最小X</span></span><br><span class="line">                    <span class="number">180</span>, <span class="comment">-- 最大X</span></span><br><span class="line">                    <span class="number">0.005</span>), <span class="comment">-- 容差0.005度</span></span><br><span class="line">    SDO_DIM_ELEMENT(<span class="string">'Y'</span>, <span class="comment">-- 第二个元键名称</span></span><br><span class="line">                    -<span class="number">90</span>, <span class="comment">-- 最小Y</span></span><br><span class="line">                    <span class="number">90</span>, <span class="comment">-- 最大Y</span></span><br><span class="line">                    <span class="number">0.005</span>) <span class="comment">-- 容差0.005度</span></span><br><span class="line">    ),</span><br><span class="line">   <span class="number">4326</span></span><br><span class="line">  <span class="comment">-- 8307 -- SRID</span></span><br><span class="line">   );</span></span><br><span class="line">   </span><br><span class="line"><span class="operator"><span class="keyword">select</span> * <span class="keyword">from</span> user_indexes <span class="keyword">where</span> table_name = <span class="string">'TGNSS'</span>;</span></span><br><span class="line"><span class="operator"><span class="keyword">select</span> * <span class="keyword">from</span> user_ind_columns <span class="keyword">where</span> index_name=<span class="keyword">upper</span>(<span class="string">'&amp;IDX_TASK_GNSS_SPATIAL'</span>);</span></span><br><span class="line"><span class="operator"><span class="keyword">CREATE</span> <span class="keyword">INDEX</span> IDX_TGNSS_Spatial <span class="keyword">ON</span> TGNSS(GEOM) <span class="keyword">INDEXTYPE</span> <span class="keyword">IS</span> MDSYS.SPATIAL_INDEX;</span></span><br><span class="line"><span class="operator"><span class="keyword">CREATE</span> <span class="keyword">INDEX</span> IDX_TGEOCONPOINT_Spatial <span class="keyword">ON</span> TGEOCONPOINT(GEOM) <span class="keyword">INDEXTYPE</span> <span class="keyword">IS</span> MDSYS.SPATIAL_INDEX;</span>  </span><br><span class="line"><span class="operator"><span class="keyword">CREATE</span> <span class="keyword">INDEX</span> IDX_TLEVELLINE_Spatial <span class="keyword">ON</span> TLEVELLINE(GEOM) <span class="keyword">INDEXTYPE</span> <span class="keyword">IS</span> MDSYS.SPATIAL_INDEX;</span></span><br><span class="line"><span class="comment">--CREATE INDEX IDX_VGNSS_Spatial ON VGNSS(GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX;</span></span><br><span class="line"><span class="comment">--CREATE INDEX IDX_VGEOCONPOINT_Spatial ON VGEOCONPOINT(GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX;</span></span><br><span class="line"><span class="operator"><span class="keyword">drop</span> <span class="keyword">index</span> IDX_TGNSS_Spatial;</span></span><br><span class="line"><span class="operator"><span class="keyword">drop</span> <span class="keyword">index</span> IDX_TGEOCONPOINT_Spatial;</span></span><br><span class="line"><span class="operator"><span class="keyword">drop</span> <span class="keyword">index</span> IDX_TLEVELLINE_Spatial;</span></span><br><span class="line"><span class="operator"><span class="keyword">select</span> <span class="keyword">t</span>.*, <span class="keyword">t</span>.<span class="keyword">rowid</span> <span class="keyword">from</span> tgnss <span class="keyword">t</span>;</span></span><br><span class="line"><span class="operator"><span class="keyword">insert</span> <span class="keyword">into</span> tgnss(FID, STATION_NAME, LONGITUDE, latitude, province, point_category, station_category, geom) <span class="keyword">values</span>(</span><br><span class="line">       <span class="string">'DBD15B295DAC47059343F6A82D6DC9A2'</span>,</span><br><span class="line">       <span class="string">'曲阳'</span>,</span><br><span class="line">       <span class="number">114.69</span>,</span><br><span class="line">       <span class="number">38.63</span>,</span><br><span class="line">       <span class="string">'河北'</span>,</span><br><span class="line">       <span class="string">'改造站'</span>,</span><br><span class="line">       <span class="string">'土层'</span>,</span><br><span class="line">       MDSYS.Sdo_Geometry(</span><br><span class="line">            <span class="number">2001</span>,</span><br><span class="line">            <span class="number">4326</span>,</span><br><span class="line">            <span class="literal">null</span>,</span><br><span class="line">            MDSYS.Sdo_Elem_Info_Array(<span class="number">1</span>,<span class="number">1</span>,<span class="number">1</span>),</span><br><span class="line">            MDSYS.Sdo_Ordinate_Array(<span class="number">114.69</span>, <span class="number">38.63</span>)</span><br><span class="line">       ));</span></span><br><span class="line">       </span><br><span class="line"><span class="operator"><span class="keyword">insert</span> <span class="keyword">into</span> tgnss(FID, STATION_NAME, LONGITUDE, latitude, province, point_category, station_category, geom) <span class="keyword">values</span>(</span><br><span class="line">       <span class="string">'E219CE03E4794AFA82BC304A6409DD89'</span>,</span><br><span class="line">       <span class="string">'延庆'</span>,</span><br><span class="line">       <span class="number">116.402222222222</span>,</span><br><span class="line">       <span class="number">40.5227777777778</span>,</span><br><span class="line">       <span class="string">'北京'</span>,</span><br><span class="line">       <span class="string">'新建站'</span>,</span><br><span class="line">       <span class="string">'基岩'</span>,</span><br><span class="line">       MDSYS.Sdo_Geometry(</span><br><span class="line">            <span class="number">2001</span>,</span><br><span class="line">            <span class="number">4326</span>,</span><br><span class="line">            <span class="literal">null</span>,</span><br><span class="line">            MDSYS.Sdo_Elem_Info_Array(<span class="number">1</span>,<span class="number">1</span>,<span class="number">1</span>),</span><br><span class="line">            MDSYS.Sdo_Ordinate_Array(<span class="number">116.40222222222</span>, <span class="number">40.5227777777778</span>)</span><br><span class="line">       ));</span></span><br><span class="line">       </span><br><span class="line"><span class="operator"><span class="keyword">insert</span> <span class="keyword">into</span> tgeoconpoint(FID, POINT_NAME, LONGITUDE, latitude, diff_level, accu_level, province, geom, point_no) <span class="keyword">values</span>(</span><br><span class="line">       <span class="string">'C54BD8AF897A4AE1A8277E7CAD21FE5E'</span>,</span><br><span class="line">       <span class="string">'吉尔赤'</span>,</span><br><span class="line">       <span class="number">101.481</span>,</span><br><span class="line">       <span class="number">33.1204</span>,</span><br><span class="line">       <span class="string">'III'</span>,</span><br><span class="line">       <span class="string">''</span>,</span><br><span class="line">       <span class="string">'陕西局'</span>,</span><br><span class="line">       MDSYS.Sdo_Geometry(</span><br><span class="line">            <span class="number">2001</span>,</span><br><span class="line">            <span class="number">4326</span>,</span><br><span class="line">            <span class="literal">null</span>,</span><br><span class="line">            MDSYS.Sdo_Elem_Info_Array(<span class="number">1</span>,<span class="number">1</span>,<span class="number">1</span>),</span><br><span class="line">            MDSYS.Sdo_Ordinate_Array(<span class="number">114.69</span>, <span class="number">38.63</span>)</span><br><span class="line">       ),</span><br><span class="line">       <span class="number">2518</span>);</span></span><br><span class="line">       </span><br><span class="line">       </span><br><span class="line"><span class="operator"><span class="keyword">insert</span> <span class="keyword">into</span> tlevelline(FID, LINE_NUM, LINE_NAME, START_POINT, end_point, diff_level, <span class="keyword">length</span>, pointsumnum, bedrocknum, basenum, generalnum, gpsnum, proposebedrocknum, geom) <span class="keyword">values</span>(</span><br><span class="line">       <span class="string">'C9D46E977FF54BD19EF4A9B3F240CEF9'</span>,</span><br><span class="line">       <span class="number">1</span>,</span><br><span class="line">       <span class="string">'线1'</span>,</span><br><span class="line">       <span class="string">'Ⅰ刘岷４６乙'</span>,</span><br><span class="line">       <span class="string">'Ⅰ望子关基岩点'</span>,</span><br><span class="line">       <span class="string">'III'</span>,</span><br><span class="line">       <span class="string">'450'</span>,</span><br><span class="line">       <span class="number">130</span>,</span><br><span class="line">       <span class="number">0</span>,</span><br><span class="line">       <span class="number">7</span>,</span><br><span class="line">       <span class="number">122</span>,</span><br><span class="line">       <span class="number">0</span>,</span><br><span class="line">       <span class="number">1</span>,</span><br><span class="line">       MDSYS.Sdo_Geometry(</span><br><span class="line">            <span class="number">2002</span>,</span><br><span class="line">            <span class="number">4326</span>,</span><br><span class="line">            <span class="literal">null</span>,</span><br><span class="line">            MDSYS.Sdo_Elem_Info_Array(<span class="number">1</span>,<span class="number">2</span>,<span class="number">1</span>),</span><br><span class="line">            MDSYS.Sdo_Ordinate_Array(<span class="number">117.27748</span>,<span class="number">29.545202</span>, <span class="number">117.170352</span>,<span class="number">29.548818</span>, <span class="number">117.096192</span>,<span class="number">29.51263</span>)</span><br><span class="line">       ));</span></span><br><span class="line"><span class="operator"><span class="keyword">select</span> * <span class="keyword">from</span> vGNSS;</span></span><br><span class="line"><span class="operator"><span class="keyword">select</span> * <span class="keyword">from</span> vgeoconpoint;</span></span><br><span class="line"><span class="operator"><span class="keyword">select</span> * <span class="keyword">from</span> vlevelline;</span></span><br><span class="line"><span class="operator"><span class="keyword">select</span> * <span class="keyword">from</span> TDICT_COMMON <span class="keyword">where</span> FDICTTYPE=<span class="string">'承担单位'</span> <span class="keyword">order</span> <span class="keyword">by</span> FSEQNO;</span></span><br><span class="line"><span class="operator"><span class="keyword">select</span> *</span><br><span class="line">  <span class="keyword">from</span> vgnss</span><br><span class="line"> <span class="keyword">where</span> SDO_RELATE(GEOM,</span><br><span class="line">                  sdo_geometry(<span class="string">'POLYGON((69.76880795928 12.254670943420997,69.76880795928 56.81521781842099,139.46607358428 56.815217818421004,139.46607358428002 12.254670943420997,69.76880795928 12.254670943420997))'</span>,</span><br><span class="line">                               <span class="number">4326</span>),</span><br><span class="line">                  <span class="string">'mask=ANYINTERACT'</span>) = <span class="string">'TRUE'</span></span></span><br></pre></td></tr></table></figure>
<h2 id="u53C2_u8003_u94FE_u63A5"><a href="#u53C2_u8003_u94FE_u63A5" class="headerlink" title="参考链接"></a>参考链接</h2>
      
    </div>
    <footer class="article-footer">
      <a data-url="http://yoursite.com/2016/01/27/database/10.oracle spatial/" data-id="cijzzpvi100h31cfslq8xy4i2" class="article-share-link">Share</a>
      
      
  <ul class="article-tag-list"><li class="article-tag-list-item"><a class="article-tag-list-link" href="/tags/database/">database</a></li></ul>

    </footer>
  </div>
  
    
<nav id="article-nav">
  
    <a href="/2016/01/27/database/11.java调用oracle存储过程/" id="article-nav-newer" class="article-nav-link-wrap">
      <strong class="article-nav-caption">Newer</strong>
      <div class="article-nav-title">
        
          oracle spatial
        
      </div>
    </a>
  
  
    <a href="/2016/01/27/database/9.oracle学习/" id="article-nav-older" class="article-nav-link-wrap">
      <strong class="article-nav-caption">Older</strong>
      <div class="article-nav-title">oracle学习</div>
    </a>
  
</nav>

  
</article>

</section>
        
          <aside id="sidebar">
  
    
  <div class="widget-wrap">
    <h3 class="widget-title">Categories</h3>
    <div class="widget">
      <ul class="category-list"><li class="category-list-item"><a class="category-list-link" href="/categories/cache/">cache</a><span class="category-list-count">3</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/database/">database</a><span class="category-list-count">13</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/docker/">docker</a><span class="category-list-count">6</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/gis/">gis</a><span class="category-list-count">4</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/git/">git</a><span class="category-list-count">2</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/go/">go</a><span class="category-list-count">1</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/gradle/">gradle</a><span class="category-list-count">1</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/groovy/">groovy</a><span class="category-list-count">1</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/hadoop/">hadoop</a><span class="category-list-count">1</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/java/">java</a><span class="category-list-count">18</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/linux/">linux</a><span class="category-list-count">4</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/log/">log</a><span class="category-list-count">11</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/mongodb/">mongodb</a><span class="category-list-count">14</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/mq/">mq</a><span class="category-list-count">6</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/mybatis/">mybatis</a><span class="category-list-count">9</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/netty/">netty</a><span class="category-list-count">1</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/nginx/">nginx</a><span class="category-list-count">3</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/nio/">nio</a><span class="category-list-count">19</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/nodejs/">nodejs</a><span class="category-list-count">1</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/redis/">redis</a><span class="category-list-count">6</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/rpc/">rpc</a><span class="category-list-count">14</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/spring/">spring</a><span class="category-list-count">5</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/tomcat/">tomcat</a><span class="category-list-count">2</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/zookeeper/">zookeeper</a><span class="category-list-count">2</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/杂项/">杂项</a><span class="category-list-count">2</span></li></ul>
    </div>
  </div>

  
    
  <div class="widget-wrap">
    <h3 class="widget-title">Tags</h3>
    <div class="widget">
      <ul class="tag-list"><li class="tag-list-item"><a class="tag-list-link" href="/tags/aop/">aop</a><span class="tag-list-count">8</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/aspectj/">aspectj</a><span class="tag-list-count">3</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/cache/">cache</a><span class="tag-list-count">3</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/classloader/">classloader</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/common-loggings/">common-loggings</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/commonjs/">commonjs</a><span class="tag-list-count">4</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/database/">database</a><span class="tag-list-count">10</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/docker/">docker</a><span class="tag-list-count">6</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/dubbo/">dubbo</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/fastdfs/">fastdfs</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/gclib/">gclib</a><span class="tag-list-count">2</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/geohash/">geohash</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/gis/">gis</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/git/">git</a><span class="tag-list-count">2</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/go/">go</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/gradle/">gradle</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/groovy/">groovy</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/hadoop/">hadoop</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/hessisan/">hessisan</a><span class="tag-list-count">3</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/java/">java</a><span class="tag-list-count">48</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/javassist/">javassist</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/kafka/">kafka</a><span class="tag-list-count">3</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/linux/">linux</a><span class="tag-list-count">4</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/log/">log</a><span class="tag-list-count">11</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/log4j/">log4j</a><span class="tag-list-count">4</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/logback/">logback</a><span class="tag-list-count">5</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/map/">map</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/memecached/">memecached</a><span class="tag-list-count">2</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/mina/">mina</a><span class="tag-list-count">5</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/mongodb/">mongodb</a><span class="tag-list-count">14</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/mq/">mq</a><span class="tag-list-count">6</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/mqtt/">mqtt</a><span class="tag-list-count">2</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/mybatis/">mybatis</a><span class="tag-list-count">9</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/netty/">netty</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/nginx/">nginx</a><span class="tag-list-count">3</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/nio/">nio</a><span class="tag-list-count">5</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/nodejs/">nodejs</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/postgresql/">postgresql</a><span class="tag-list-count">2</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/protobuf/">protobuf</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/proxy/">proxy</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/push/">push</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/rabbitmq/">rabbitmq</a><span class="tag-list-count">3</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/redis/">redis</a><span class="tag-list-count">6</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/rpc/">rpc</a><span class="tag-list-count">14</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/sitemesh/">sitemesh</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/sld/">sld</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/slf4j/">slf4j</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/socket/">socket</a><span class="tag-list-count">7</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/spatialite-for-android/">spatialite for android</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/spi/">spi</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/spring/">spring</a><span class="tag-list-count">13</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/tomcat/">tomcat</a><span class="tag-list-count">2</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/transaction/">transaction</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/web/">web</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/xSocket/">xSocket</a><span class="tag-list-count">7</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/zbus/">zbus</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/zookeeper/">zookeeper</a><span class="tag-list-count">2</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/数据结构/">数据结构</a><span class="tag-list-count">2</span></li></ul>
    </div>
  </div>

  
    
  <div class="widget-wrap">
    <h3 class="widget-title">Tag Cloud</h3>
    <div class="widget tagcloud">
      <a href="/tags/aop/" style="font-size: 15.38px;">aop</a> <a href="/tags/aspectj/" style="font-size: 11.54px;">aspectj</a> <a href="/tags/cache/" style="font-size: 11.54px;">cache</a> <a href="/tags/classloader/" style="font-size: 10px;">classloader</a> <a href="/tags/common-loggings/" style="font-size: 10px;">common-loggings</a> <a href="/tags/commonjs/" style="font-size: 12.31px;">commonjs</a> <a href="/tags/database/" style="font-size: 16.92px;">database</a> <a href="/tags/docker/" style="font-size: 13.85px;">docker</a> <a href="/tags/dubbo/" style="font-size: 10px;">dubbo</a> <a href="/tags/fastdfs/" style="font-size: 10px;">fastdfs</a> <a href="/tags/gclib/" style="font-size: 10.77px;">gclib</a> <a href="/tags/geohash/" style="font-size: 10px;">geohash</a> <a href="/tags/gis/" style="font-size: 10px;">gis</a> <a href="/tags/git/" style="font-size: 10.77px;">git</a> <a href="/tags/go/" style="font-size: 10px;">go</a> <a href="/tags/gradle/" style="font-size: 10px;">gradle</a> <a href="/tags/groovy/" style="font-size: 10px;">groovy</a> <a href="/tags/hadoop/" style="font-size: 10px;">hadoop</a> <a href="/tags/hessisan/" style="font-size: 11.54px;">hessisan</a> <a href="/tags/java/" style="font-size: 20px;">java</a> <a href="/tags/javassist/" style="font-size: 10px;">javassist</a> <a href="/tags/kafka/" style="font-size: 11.54px;">kafka</a> <a href="/tags/linux/" style="font-size: 12.31px;">linux</a> <a href="/tags/log/" style="font-size: 17.69px;">log</a> <a href="/tags/log4j/" style="font-size: 12.31px;">log4j</a> <a href="/tags/logback/" style="font-size: 13.08px;">logback</a> <a href="/tags/map/" style="font-size: 10px;">map</a> <a href="/tags/memecached/" style="font-size: 10.77px;">memecached</a> <a href="/tags/mina/" style="font-size: 13.08px;">mina</a> <a href="/tags/mongodb/" style="font-size: 19.23px;">mongodb</a> <a href="/tags/mq/" style="font-size: 13.85px;">mq</a> <a href="/tags/mqtt/" style="font-size: 10.77px;">mqtt</a> <a href="/tags/mybatis/" style="font-size: 16.15px;">mybatis</a> <a href="/tags/netty/" style="font-size: 10px;">netty</a> <a href="/tags/nginx/" style="font-size: 11.54px;">nginx</a> <a href="/tags/nio/" style="font-size: 13.08px;">nio</a> <a href="/tags/nodejs/" style="font-size: 10px;">nodejs</a> <a href="/tags/postgresql/" style="font-size: 10.77px;">postgresql</a> <a href="/tags/protobuf/" style="font-size: 10px;">protobuf</a> <a href="/tags/proxy/" style="font-size: 10px;">proxy</a> <a href="/tags/push/" style="font-size: 10px;">push</a> <a href="/tags/rabbitmq/" style="font-size: 11.54px;">rabbitmq</a> <a href="/tags/redis/" style="font-size: 13.85px;">redis</a> <a href="/tags/rpc/" style="font-size: 19.23px;">rpc</a> <a href="/tags/sitemesh/" style="font-size: 10px;">sitemesh</a> <a href="/tags/sld/" style="font-size: 10px;">sld</a> <a href="/tags/slf4j/" style="font-size: 10px;">slf4j</a> <a href="/tags/socket/" style="font-size: 14.62px;">socket</a> <a href="/tags/spatialite-for-android/" style="font-size: 10px;">spatialite for android</a> <a href="/tags/spi/" style="font-size: 10px;">spi</a> <a href="/tags/spring/" style="font-size: 18.46px;">spring</a> <a href="/tags/tomcat/" style="font-size: 10.77px;">tomcat</a> <a href="/tags/transaction/" style="font-size: 10px;">transaction</a> <a href="/tags/web/" style="font-size: 10px;">web</a> <a href="/tags/xSocket/" style="font-size: 14.62px;">xSocket</a> <a href="/tags/zbus/" style="font-size: 10px;">zbus</a> <a href="/tags/zookeeper/" style="font-size: 10.77px;">zookeeper</a> <a href="/tags/数据结构/" style="font-size: 10.77px;">数据结构</a>
    </div>
  </div>

  
    
  <div class="widget-wrap">
    <h3 class="widget-title">Archives</h3>
    <div class="widget">
      <ul class="archive-list"><li class="archive-list-item"><a class="archive-list-link" href="/archives/2016/01/">January 2016</a><span class="archive-list-count">67</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2015/12/">December 2015</a><span class="archive-list-count">81</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2015/11/">November 2015</a><span class="archive-list-count">2</span></li></ul>
    </div>
  </div>

  
    
  <div class="widget-wrap">
    <h3 class="widget-title">Recents</h3>
    <div class="widget">
      <ul>
        
          <li>
            <a href="/2016/01/30/资料/">(no title)</a>
          </li>
        
          <li>
            <a href="/2016/01/30/java/13.Classloader系列一/">ClassLoader系列一</a>
          </li>
        
          <li>
            <a href="/2016/01/29/hadoop/1.hadoop系列之源码编译/">hadoop系列一之源码编译</a>
          </li>
        
          <li>
            <a href="/2016/01/29/go/1.GO系列之入门/">Go系列一之入门</a>
          </li>
        
          <li>
            <a href="/2016/01/28/tomcat/2.tomcat性能优化/">tomcat性能优化</a>
          </li>
        
      </ul>
    </div>
  </div>

  
</aside>
        
      </div>
      <footer id="footer">
  
  <div class="outer">
    <div id="footer-info" class="inner">
      &copy; 2016 John Doe<br>
      Powered by <a href="http://hexo.io/" target="_blank">Hexo</a>
    </div>
  </div>
</footer>
    </div>
    <nav id="mobile-nav">
  
    <a href="/" class="mobile-nav-link">Home</a>
  
    <a href="/archives" class="mobile-nav-link">Archives</a>
  
</nav>
    


<script src="http://libs.baidu.com/jquery/2.0.3/jquery.min.js"></script>


  <link rel="stylesheet" href="/fancybox/jquery.fancybox.css" type="text/css">
  <script src="/fancybox/jquery.fancybox.pack.js" type="text/javascript"></script>


<script src="/js/script.js" type="text/javascript"></script>

  </div>
</body>
</html>